insert into autor values(autor_sequence.nextval, 'karel','capek');
insert into autor values(autor_sequence.nextval, 'ota','pavel');
insert into autor values(autor_sequence.nextval, 'michal','vieweg');
insert into autor values(autor_sequence.nextval, 'zdenek','jirotka');

insert into nakladatelstvi values(nakladatelstvi_sequence.nextval,'abatros','pod smrkem','paraha 3','15','74120');
insert into nakladatelstvi values(nakladatelstvi_sequence.nextval,'abatros2','nad smrkem','paraha 3','16','74120');
insert into nakladatelstvi values(nakladatelstvi_sequence.nextval,'abatros3','za smrkem','paraha 3','17','74120');
insert into nakladatelstvi values(nakladatelstvi_sequence.nextval,'abatros4','pred smrkem','paraha 3','18','74120');
insert into nakladatelstvi values(nakladatelstvi_sequence.nextval,'abatros5','u smrku','paraha 3','19','74120');

insert into oddeleni values(oddeleni_sequence.nextval,'knihy1',0);
insert into oddeleni values(oddeleni_sequence.nextval,'enczklopedie',0);
insert into oddeleni values(oddeleni_sequence.nextval,'beletrie',0);

set serveroutput on;
insert into kniha values(kniha_sequence.nextval,'Kniha 1',10,NULL,'1945',18001,17001);
insert into kniha values(kniha_sequence.nextval,'Kniha 2',10,NULL,'1945',18002,17002);
insert into kniha values(kniha_sequence.nextval,'Kniha 3',10,NULL,'1945',18003,17002);
insert into kniha values(kniha_sequence.nextval,'Kniha 4',10,NULL,'1945',18001,17001);
insert into kniha values(kniha_sequence.nextval,'Kniha 5',10,NULL,'1945',18002,17001);

insert into napsal values(15019,10001);
insert into napsal values(15018,10002);
insert into napsal values(15019,10003);
insert into napsal values(15020,10004);
insert into napsal values(15021,10002);
insert into napsal values(15021,10003);
insert into napsal values(15018,10004);

insert into uzivatel(id, jm_u, prijmeni_u,login_u,pass_u,ulice_u,mesto_u,cp_u,psc_u,zamestnan_od,zamestnan_do,plat,rodne_cislo,is_admin) values(uzivatel_sequence.nextval,
'Jakub','Lattenberk','lattis','lattisek','Potocni','Mikulovice', '348', '790 84',to_date('22.03.2012', 'DD.MM.YYYY'), null,20000,'880917/6255',1);
insert into uzivatel(id, jm_u, prijmeni_u,login_u,pass_u,ulice_u,mesto_u,cp_u,psc_u,darum_registrace,obdobi_od,obdobi_do) values(uzivatel_sequence.nextval,
'Jakub','Lattenberk','lattis_u','lattisek','Potocni','Mikulovice', '348', '790 84',to_date('22.03.2012', 'DD.MM.YYYY'),to_date('22.03.2012', 'DD.MM.YYYY'),to_date('22.09.2012', 'DD.MM.YYYY'));
insert into uzivatel(id, jm_u, prijmeni_u,login_u,pass_u,ulice_u,mesto_u,cp_u,psc_u,darum_registrace,obdobi_od,obdobi_do) values(uzivatel_sequence.nextval,
'Pepa','Jezevec','jezevec','lattisek','Potocni','Mikulovice', '348', '790 84',to_date('22.03.2012', 'DD.MM.YYYY'),to_date('22.09.2011', 'DD.MM.YYYY'),to_date('20.03.2012', 'DD.MM.YYYY'));


